Oracle Session

• version: 3.8

• Compatibility: v 7.6.8

• Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Metric Collection Interval (Mandatory)

• Operation: monitors the Oracle Session.

• Change from Last Version: Improvement: Test Methods added for Demo Server

---

• version: 3.7

• Compatibility: v 7.5.3

• Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Instance Name (Mandatory), Metric Collection Interval (Mandatory)

• Operation: monitors the Oracle Session.

• Plugin-Metrics:

Metric	Data Type
Connected Sessions	Numeric
Active Sessions	Numeric
Idle Sessions	Numeric
Blocked Sessions	Numeric

Instance columns:

Session Id

Metric	Data Type
Session Id	String
Session Command	String
Session Status	String
Session Remote Host	String
Session User	String
Session Query	String
Session Program	String
Session Duration (Seconds)	Numeric
Session Duration	String
Session Logon Time	String
Session CPU (ms)	Numeric
Session Memory Sorts	Numeric
Session Disk Sorts	Numeric
Session Table Scans	Numeric
Session Physical Reads	Numeric
Session Logical Reads	Numeric
Session Commits	Numeric
Session Cursors	Numeric

Waiting Session Id

Metric	Data Type
Waiting Session Id	String
Session Serial Id	String
Session Wait Duration (Seconds)	Numeric

Blocking Session Id

Metric	Data Type
Blocking Session Id	String
Blocked Session Id	String
Blocking Session User	String
Blocked Session User	String
Blocking Session Program	String
Blocked Session Program	String
Blocking Session Host	String
Blocked Session Host	String
Session Lock Type	String
Session Blocking Lock Mode	String
Session Blocked Lock Mode	String
Session Lock Id2	Numeric
Session Lock Id1	Numeric